Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	169302
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	22.0 MiB
Average record size in memory	136.0 B

Variable types

NUM	13
BOOL	2
CAT	2

Warnings

`name` has a high cardinality: 132939 distinct values	High cardinality
`artists` has a high cardinality: 33375 distinct values	High cardinality
`name` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`instrumentalness` has 46055 (27.2%) zeros	Zeros
`key` has 21431 (12.7%) zeros	Zeros
`popularity` has 26802 (15.8%) zeros	Zeros

Reproduction

Analysis started	2020-09-16 13:32:12.127976
Analysis finished	2020-09-16 13:32:52.102698
Duration	39.97 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	169302
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	84849.84659
Minimum	0
Maximum	169908
Zeros	1
Zeros (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	8474.05
Q1	42392.25
median	84813.5
Q3	127255.75
95-th percentile	161353.95
Maximum	169908
Range	169908
Interquartile range (IQR)	84863.5

Descriptive statistics

Standard deviation	49030.07791
Coefficient of variation (CV)	0.5778452157
Kurtosis	-1.198528767
Mean	84849.84659
Median Absolute Deviation (MAD)	42432
Skewness	0.0024169362
Sum	1.436524873e+10
Variance	2403948540
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2047	1	< 0.1%
159079	1	< 0.1%
163173	1	< 0.1%
161124	1	< 0.1%
150883	1	< 0.1%
148834	1	< 0.1%
154977	1	< 0.1%
152928	1	< 0.1%
44351	1	< 0.1%
42302	1	< 0.1%
Other values (169292)	169292	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
169908	1	< 0.1%
169907	1	< 0.1%
169906	1	< 0.1%
169905	1	< 0.1%
169904	1	< 0.1%

name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	132939
Distinct (%)	78.5%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Summertime	62
Overture	43
Home	40
Stay	34
You	33
Other values (132934)	169090

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Summertime	62	< 0.1%
Overture	43	< 0.1%
Home	40	< 0.1%
Stay	34	< 0.1%
You	33	< 0.1%
I Love You	32	< 0.1%
Forever	32	< 0.1%
Angel	31	< 0.1%
Paradise	31	< 0.1%
Runaway	30	< 0.1%
Other values (132929)	168934	99.8%

Frequencies of value counts

Unique

Unique	113871 ?
Unique (%)	67.3%

Histogram of lengths of the category

Length

Max length	255
Median length	18
Mean length	23.50569987
Min length	1

artists
Categorical

HIGH CARDINALITY

Distinct	33375
Distinct (%)	19.7%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

['Эрнест Хемингуэй']	1215
['Francisco Canaro']	938
['Эрих Мария Ремарк']	781
['Ignacio Corsini']	620
['Frank Sinatra']	592
Other values (33370)	165156

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
['Эрнест Хемингуэй']	1215	0.7%
['Francisco Canaro']	938	0.6%
['Эрих Мария Ремарк']	781	0.5%
['Ignacio Corsini']	620	0.4%
['Frank Sinatra']	592	0.3%
['Bob Dylan']	539	0.3%
['The Rolling Stones']	512	0.3%
['Johnny Cash']	501	0.3%
['The Beach Boys']	491	0.3%
['Elvis Presley']	488	0.3%
Other values (33365)	162625	96.1%

Frequencies of value counts

Unique

Unique	19627 ?
Unique (%)	11.6%

Histogram of lengths of the category

Length

Max length	661
Median length	17
Mean length	23.24452753
Min length	5

duration_ms
Real number (ℝ_≥0)

Distinct	50212
Distinct (%)	29.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	231435.0531
Minimum	5108
Maximum	5403500
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	5108
5-th percentile	112667
Q1	171187
median	208621
Q3	262907
95-th percentile	409640
Maximum	5403500
Range	5398392
Interquartile range (IQR)	91720

Descriptive statistics

Standard deviation	121133.4509
Coefficient of variation (CV)	0.523401487
Kurtosis	117.0778563
Mean	231435.0531
Median Absolute Deviation (MAD)	44088
Skewness	6.528090803
Sum	3.918241735e+10
Variance	1.467331293e+10
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
192000	55	< 0.1%
180000	53	< 0.1%
186000	50	< 0.1%
240000	50	< 0.1%
184000	49	< 0.1%
160000	47	< 0.1%
168000	45	< 0.1%
169000	45	< 0.1%
170000	44	< 0.1%
175000	44	< 0.1%
Other values (50202)	168820	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5108	1	< 0.1%
5991	1	< 0.1%
6362	1	< 0.1%
6467	1	< 0.1%
8853	2	< 0.1%

Value	Count	Frequency (%)
5403500	1	< 0.1%
4270034	1	< 0.1%
4269407	1	< 0.1%
4120258	2	< 0.1%
3816373	1	< 0.1%

year
Real number (ℝ_≥0)

Distinct	100
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1977.330362
Minimum	1921
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1921
5-th percentile	1935
Q1	1957
median	1978
Q3	1999
95-th percentile	2016
Maximum	2020
Range	99
Interquartile range (IQR)	42

Descriptive statistics

Standard deviation	25.54741476
Coefficient of variation (CV)	0.01292015499
Kurtosis	-1.021059253
Mean	1977.330362
Median Absolute Deviation (MAD)	21
Skewness	-0.1368376892
Sum	334765985
Variance	652.6704007
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1993	2000	1.2%
1996	2000	1.2%
1994	2000	1.2%
1966	2000	1.2%
1992	2000	1.2%
1962	2000	1.2%
1990	2000	1.2%
1989	2000	1.2%
1988	2000	1.2%
1986	2000	1.2%
Other values (90)	149302	88.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1921	128	0.1%
1922	72	< 0.1%
1923	169	0.1%
1924	237	0.1%
1925	263	0.2%

Value	Count	Frequency (%)
2020	1741	1.0%
2019	2000	1.2%
2018	1999	1.2%
2017	1999	1.2%
2016	1969	1.2%

acousticness
Real number (ℝ_≥0)

Distinct	4714
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.4917566408
Minimum	0
Maximum	0.996
Zeros	21
Zeros (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.00143
Q1	0.093625
median	0.489
Q3	0.886
95-th percentile	0.992
Maximum	0.996
Range	0.996
Interquartile range (IQR)	0.792375

Descriptive statistics

Standard deviation	0.3762684712
Coefficient of variation (CV)	0.7651517844
Kurtosis	-1.612390863
Mean	0.4917566408
Median Absolute Deviation (MAD)	0.396
Skewness	0.01405904966
Sum	83255.3828
Variance	0.1415779624
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.995	2971	1.8%
0.994	2245	1.3%
0.993	1697	1.0%
0.992	1466	0.9%
0.991	1239	0.7%
0.99	1156	0.7%
0.996	1031	0.6%
0.989	1022	0.6%
0.988	896	0.5%
0.987	800	0.5%
Other values (4704)	154779	91.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	21	< 0.1%
1e-06	1	< 0.1%
1.01e-06	3	< 0.1%
1.03e-06	1	< 0.1%
1.05e-06	2	< 0.1%

Value	Count	Frequency (%)
0.996	1031	0.6%
0.995	2971	1.8%
0.994	2245	1.3%
0.993	1697	1.0%
0.992	1466	0.9%

danceability
Real number (ℝ_≥0)

Distinct	1232
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.5386953793
Minimum	0
Maximum	0.988
Zeros	146
Zeros (%)	0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.233
Q1	0.418
median	0.549
Q3	0.668
95-th percentile	0.813
Maximum	0.988
Range	0.988
Interquartile range (IQR)	0.25

Descriptive statistics

Standard deviation	0.1751954374
Coefficient of variation (CV)	0.3252217192
Kurtosis	-0.4202513441
Mean	0.5386953793
Median Absolute Deviation (MAD)	0.124
Skewness	-0.2156799167
Sum	91202.2051
Variance	0.03069344128
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.565	436	0.3%
0.578	411	0.2%
0.612	410	0.2%
0.559	401	0.2%
0.556	399	0.2%
0.622	397	0.2%
0.61	397	0.2%
0.602	395	0.2%
0.546	391	0.2%
0.545	390	0.2%
Other values (1222)	165275	97.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	146	0.1%
0.0551	1	< 0.1%
0.0559	2	< 0.1%
0.0562	1	< 0.1%
0.0569	2	< 0.1%

Value	Count	Frequency (%)
0.988	1	< 0.1%
0.986	2	< 0.1%
0.985	1	< 0.1%
0.982	1	< 0.1%
0.98	3	< 0.1%

energy
Real number (ℝ_≥0)

Distinct	2332
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.4895964759
Minimum	0
Maximum	1
Zeros	10
Zeros (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.077505
Q1	0.264
median	0.482
Q3	0.71075
95-th percentile	0.925
Maximum	1
Range	1
Interquartile range (IQR)	0.44675

Descriptive statistics

Standard deviation	0.267074182
Coefficient of variation (CV)	0.5454985791
Kurtosis	-1.096355636
Mean	0.4895964759
Median Absolute Deviation (MAD)	0.223
Skewness	0.07442018773
Sum	82889.66256
Variance	0.07132861867
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.28	235	0.1%
0.459	234	0.1%
0.254	233	0.1%
0.341	232	0.1%
0.306	232	0.1%
0.299	231	0.1%
0.31	230	0.1%
0.32	230	0.1%
0.245	230	0.1%
0.219	227	0.1%
Other values (2322)	166988	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10	< 0.1%
1.99e-05	2	< 0.1%
2.01e-05	6	< 0.1%
2.02e-05	5	< 0.1%
2.03e-05	14	< 0.1%

Value	Count	Frequency (%)
1	20	< 0.1%
0.999	25	< 0.1%
0.998	38	< 0.1%
0.997	56	< 0.1%
0.996	67	< 0.1%

instrumentalness
Real number (ℝ_≥0)

ZEROS

Distinct	5401
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1604745519
Minimum	0
Maximum	1
Zeros	46055
Zeros (%)	27.2%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.000197
Q3	0.083275
95-th percentile	0.903
Maximum	1
Range	1
Interquartile range (IQR)	0.083275

Descriptive statistics

Standard deviation	0.3079964242
Coefficient of variation (CV)	1.919285149
Kurtosis	1.171686173
Mean	0.1604745519
Median Absolute Deviation (MAD)	0.000197
Skewness	1.695866039
Sum	27168.66258
Variance	0.0948617973
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	46055	27.2%
0.917	192	0.1%
0.916	190	0.1%
0.913	186	0.1%
0.904	179	0.1%
0.901	177	0.1%
0.922	173	0.1%
0.894	171	0.1%
0.914	171	0.1%
0.903	170	0.1%
Other values (5391)	121638	71.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	46055	27.2%
1e-06	28	< 0.1%
1.01e-06	67	< 0.1%
1.02e-06	89	0.1%
1.03e-06	70	< 0.1%

Value	Count	Frequency (%)
1	10	< 0.1%
0.999	13	< 0.1%
0.998	10	< 0.1%
0.997	3	< 0.1%
0.996	6	< 0.1%

loudness
Real number (ℝ)

Distinct	25313
Distinct (%)	15.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-11.34211645
Minimum	-60
Maximum	3.855
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	-60
5-th percentile	-21.80895
Q1	-14.42975
median	-10.453
Q3	-7.109
95-th percentile	-4.09305
Maximum	3.855
Range	63.855
Interquartile range (IQR)	7.32075

Descriptive statistics

Standard deviation	5.642668316
Coefficient of variation (CV)	-0.4974969476
Kurtosis	1.932477728
Mean	-11.34211645
Median Absolute Deviation (MAD)	3.59
Skewness	-1.071872125
Sum	-1920243
Variance	31.83970572
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-7.006	27	< 0.1%
-7.436	27	< 0.1%
-7.632	26	< 0.1%
-9.298	26	< 0.1%
-8.32	26	< 0.1%
-6.942	26	< 0.1%
-11.815	25	< 0.1%
-7.566	25	< 0.1%
-11.451	25	< 0.1%
-8.789	25	< 0.1%
Other values (25303)	169044	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-60	9	< 0.1%
-55	1	< 0.1%
-54.376	1	< 0.1%
-51.123	1	< 0.1%
-51.08	1	< 0.1%

Value	Count	Frequency (%)
3.855	1	< 0.1%
3.744	1	< 0.1%
2.799	1	< 0.1%
1.963	1	< 0.1%
1.83	1	< 0.1%

speechiness
Real number (ℝ_≥0)

Distinct	1628
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.09419094281
Minimum	0
Maximum	0.969
Zeros	147
Zeros (%)	0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0281
Q1	0.0349
median	0.0451
Q3	0.0755
95-th percentile	0.332
Maximum	0.969
Range	0.969
Interquartile range (IQR)	0.0406

Descriptive statistics

Standard deviation	0.1501470001
Coefficient of variation (CV)	1.594070466
Kurtosis	19.30765722
Mean	0.09419094281
Median Absolute Deviation (MAD)	0.0131
Skewness	4.229128896
Sum	15946.715
Variance	0.02254412163
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0347	571	0.3%
0.0319	563	0.3%
0.0333	558	0.3%
0.0337	557	0.3%
0.0334	555	0.3%
0.0352	554	0.3%
0.0332	551	0.3%
0.0315	549	0.3%
0.0336	548	0.3%
0.034	548	0.3%
Other values (1618)	163748	96.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	147	0.1%
0.0222	1	< 0.1%
0.0223	3	< 0.1%
0.0224	5	< 0.1%
0.0225	5	< 0.1%

Value	Count	Frequency (%)
0.969	1	< 0.1%
0.968	3	< 0.1%
0.967	3	< 0.1%
0.966	17	< 0.1%
0.965	22	< 0.1%

tempo
Real number (ℝ_≥0)

Distinct	84548
Distinct (%)	49.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	116.9904707
Minimum	0
Maximum	244.091
Zeros	146
Zeros (%)	0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	74.2402
Q1	93.5885
median	114.8315
Q3	135.7445
95-th percentile	174.4717
Maximum	244.091
Range	244.091
Interquartile range (IQR)	42.156

Descriptive statistics

Standard deviation	30.71802952
Coefficient of variation (CV)	0.2625686463
Kurtosis	-0.07618982086
Mean	116.9904707
Median Absolute Deviation (MAD)	21.0875
Skewness	0.4485858734
Sum	19806720.67
Variance	943.5973373
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	146	0.1%
120	21	< 0.1%
119.989	18	< 0.1%
120.005	17	< 0.1%
119.994	17	< 0.1%
119.969	17	< 0.1%
120.012	17	< 0.1%
129.995	16	< 0.1%
120.011	16	< 0.1%
95.027	15	< 0.1%
Other values (84538)	169002	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	146	0.1%
30.946	1	< 0.1%
31.988	1	< 0.1%
32.466	1	< 0.1%
32.8	1	< 0.1%

Value	Count	Frequency (%)
244.091	1	< 0.1%
243.507	1	< 0.1%
243.372	1	< 0.1%
238.895	1	< 0.1%
236.799	1	< 0.1%

valence
Real number (ℝ_≥0)

Distinct	1739
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.5329432862
Minimum	0
Maximum	1
Zeros	183
Zeros (%)	0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0938
Q1	0.324
median	0.545
Q3	0.75
95-th percentile	0.938
Maximum	1
Range	1
Interquartile range (IQR)	0.426

Descriptive statistics

Standard deviation	0.2621413115
Coefficient of variation (CV)	0.4918746859
Kurtosis	-1.048579821
Mean	0.5329432862
Median Absolute Deviation (MAD)	0.213
Skewness	-0.1267632558
Sum	90228.36424
Variance	0.0687180672
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.961	725	0.4%
0.962	597	0.4%
0.963	526	0.3%
0.964	467	0.3%
0.965	405	0.2%
0.96	388	0.2%
0.966	355	0.2%
0.967	311	0.2%
0.968	270	0.2%
0.559	252	0.1%
Other values (1729)	165006	97.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	183	0.1%
1e-05	75	< 0.1%
6.41e-05	1	< 0.1%
0.00049	1	< 0.1%
0.000537	1	< 0.1%

Value	Count	Frequency (%)
1	3	< 0.1%
0.999	1	< 0.1%
0.998	1	< 0.1%
0.996	2	< 0.1%
0.995	1	< 0.1%

mode
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

1	119979
0	49323

Common Values
Chart

Value	Count	Frequency (%)
1	119979	70.9%
0	49323	29.1%

key
Real number (ℝ_≥0)

ZEROS

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.199761373
Minimum	0
Maximum	11
Zeros	21431
Zeros (%)	12.7%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	8
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.51507068
Coefficient of variation (CV)	0.6760061524
Kurtosis	-1.272421934
Mean	5.199761373
Median Absolute Deviation (MAD)	3
Skewness	0.004988843093
Sum	880330
Variance	12.35572188
Monotocity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	21431	12.7%
7	20697	12.2%
2	18760	11.1%
9	17580	10.4%
5	16279	9.6%
4	12881	7.6%
1	12775	7.5%
10	11984	7.1%
8	10672	6.3%
11	10552	6.2%
Other values (2)	15691	9.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	21431	12.7%
1	12775	7.5%
2	18760	11.1%
3	7139	4.2%
4	12881	7.6%

Value	Count	Frequency (%)
11	10552	6.2%
10	11984	7.1%
9	17580	10.4%
8	10672	6.3%
7	20697	12.2%

popularity
Real number (ℝ_≥0)

ZEROS

Distinct	100
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	31.65795442
Minimum	0
Maximum	100
Zeros	26802
Zeros (%)	15.8%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	12
median	34
Q3	48
95-th percentile	65
Maximum	100
Range	100
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	21.54183438
Coefficient of variation (CV)	0.6804556636
Kurtosis	-1.008177751
Mean	31.65795442
Median Absolute Deviation (MAD)	16
Skewness	-0.02573882078
Sum	5359755
Variance	464.0506287
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	26802	15.8%
42	3280	1.9%
43	3120	1.8%
40	3061	1.8%
44	3053	1.8%
41	3016	1.8%
45	2944	1.7%
38	2900	1.7%
39	2868	1.7%
35	2858	1.7%
Other values (90)	115400	68.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	26802	15.8%
1	2248	1.3%
2	1448	0.9%
3	1200	0.7%
4	1074	0.6%

Value	Count	Frequency (%)
100	1	< 0.1%
99	1	< 0.1%
97	1	< 0.1%
96	1	< 0.1%
95	4	< 0.1%

explicit
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	154890
1	14412

Common Values
Chart

Value	Count	Frequency (%)
0	154890	91.5%
1	14412	8.5%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	df_index	name	artists	duration_ms	year	acousticness	danceability	energy	instrumentalness	loudness	speechiness	tempo	valence	mode	key	popularity
0	0	Singende Bataillone 1. Teil	['Carl Woitschach']	158648	1928	0.995	0.708	0.1950	0.563	-12.428	0.0506	118.469	0.7790	1	10	0
1	1	Fantasiestücke, Op. 111: Più tosto lento	['Robert Schumann', 'Vladimir Horowitz']	282133	1928	0.994	0.379	0.0135	0.901	-28.454	0.0462	83.972	0.0767	1	8	0
2	2	Chapter 1.18 - Zamek kaniowski	['Seweryn Goszczyński']	104300	1928	0.604	0.749	0.2200	0.000	-19.924	0.9290	107.177	0.8800	0	5	0
3	3	Bebamos Juntos - Instrumental (Remasterizado)	['Francisco Canaro']	180760	1928	0.995	0.781	0.1300	0.887	-14.734	0.0926	108.003	0.7200	0	1	0
4	4	Polonaise-Fantaisie in A-Flat Major, Op. 61	['Frédéric Chopin', 'Vladimir Horowitz']	687733	1928	0.990	0.210	0.2040	0.908	-16.829	0.0424	62.149	0.0693	1	11	1
5	5	Scherzo a capriccio: Presto	['Felix Mendelssohn', 'Vladimir Horowitz']	352600	1928	0.995	0.424	0.1200	0.911	-19.242	0.0593	63.521	0.2660	0	6	0
6	6	Valse oubliée No. 1 in F-Sharp Major, S. 215/1	['Franz Liszt', 'Vladimir Horowitz']	136627	1928	0.956	0.444	0.1970	0.435	-17.226	0.0400	80.495	0.3050	1	11	0
7	7	Per aspera ad astra	['Carl Woitschach']	153967	1928	0.988	0.555	0.4210	0.836	-9.878	0.0474	123.310	0.8570	1	1	0
8	8	Moneda Corriente - Remasterizado	['Francisco Canaro', 'Charlo']	162493	1928	0.995	0.683	0.2070	0.206	-9.801	0.1270	119.833	0.4930	0	9	0
9	9	Chapter 1.3 - Zamek kaniowski	['Seweryn Goszczyński']	111600	1928	0.846	0.674	0.2050	0.000	-20.119	0.9540	81.249	0.7590	1	9	0

Last rows

	df_index	name	artists	duration_ms	year	acousticness	danceability	energy	instrumentalness	loudness	speechiness	tempo	valence	mode	key	popularity	explicit
169292	169899	Rough Ryder	['YoungBoy Never Broke Again']	161019	2020	0.3710	0.623	0.721	0.000000	-4.584	0.3390	166.637	0.719	0	10	64	1
169293	169900	I Dare You	['Kelly Clarkson']	216107	2020	0.0452	0.655	0.719	0.000018	-7.400	0.0368	124.034	0.435	1	2	69	0
169294	169901	Letter To Nipsey (feat. Roddy Ricch)	['Meek Mill', 'Roddy Ricch']	167845	2020	0.2640	0.744	0.702	0.000000	-6.255	0.2880	91.885	0.338	0	7	66	1
169295	169902	Back Home (feat. Summer Walker)	['Trey Songz', 'Summer Walker']	194576	2020	0.0227	0.619	0.719	0.000000	-4.111	0.1570	86.036	0.351	1	0	69	1
169296	169903	Ojos De Maniaco	['LEGADO 7', 'Junior H']	218501	2020	0.2100	0.795	0.585	0.000001	-4.451	0.0374	97.479	0.934	1	8	68	0
169297	169904	Skechers (feat. Tyga) - Remix	['DripReport', 'Tyga']	163800	2020	0.1730	0.875	0.443	0.000032	-7.461	0.1430	100.012	0.306	1	1	75	1
169298	169905	Sweeter (feat. Terrace Martin)	['Leon Bridges', 'Terrace Martin']	167468	2020	0.0167	0.719	0.385	0.031300	-10.907	0.0403	128.000	0.270	1	8	64	0
169299	169906	How Would I Know	['Kygo', 'Oh Wonder']	180700	2020	0.5380	0.514	0.539	0.002330	-9.332	0.1050	123.700	0.153	1	7	70	0
169300	169907	I Found You	['Cash Cash', 'Andy Grammer']	167308	2020	0.0714	0.646	0.761	0.000000	-2.557	0.0385	129.916	0.472	1	1	70	0
169301	169908	More Hearts Than Mine	['Ingrid Andress']	214787	2020	0.1090	0.512	0.428	0.000000	-7.387	0.0271	80.588	0.366	1	0	65	0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows